Previous Topic

Next Topic

Order Line Record (OL)

Add OL records in the order in which you want them to display in the transaction field. The total number of order lines following an OH record is verified against the number of lines specified in the header.

Record #

Field Name

Data Type

Comments

1

Record Type

OL

Required: Always OL

2

Product Code

Char (31)

Optional: If not used, the Description becomes a required field. If specified, must exist in the Product table.

3

Product Description

Char (225)

Required if product code is left blank.

Optional if product code is used. Used to override the product description for this order.

4

Quantity Ordered

Numeric

Optional

5

Unit Price

Money

Optional: Used to override the unit price in the Product table.

6

Taxable

Boolean

Optional: Used to override the product taxation status.

7

Commission Rate

Numeric

Optional: Used to override the commission rate contained in the Product table. (Do not express the commission rate percentage as a decimal or fraction. Use a whole number.)

8

Discount

Numeric

Optional: Used to enter product-level discounts. Product-level discounts override order-level discounts for product line-items.

9

Location

Char (10)

Optional: Used to enter a warehouse location when using multiple warehouses.

10

Bin

Char (10)

Optional: Used to enter a storage bin within a warehouse.

11

UF_1

Char (30)

Optional: Used to enter and define specific order information for products.

12

UF_2

13

UF_3

14

UF_4

See Also

Using the iMIS Orders Importer

Formatting Import Data

Batch Header Record (BH)

Order Header Record (OH)

Order Address Record (OA)

Order Payment Record (OP)


ASI logo 10.6 Production Release. Updated 3/20/2006 12:52:04 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.